USE [dmae0912_sem4_g1]
Delete From Recipe_KeyWord
Delete From Recipe_Ingredient
Delete From Recipe
Delete From RecipeNameKeyWord
Delete From Ingredients
Delete From Ingredients_Category
Delete From Unit
SET IDENTITY_INSERT Unit ON
INSERT INTO [dbo].[Unit] ([ID], [Unit]) VALUES ('1', 'g')
INSERT INTO [dbo].[Unit] ([ID], [Unit]) VALUES ('2', 'kg')
INSERT INTO [dbo].[Unit] ([ID], [Unit]) VALUES ('3', 'tablespoon')
INSERT INTO [dbo].[Unit] ([ID], [Unit]) VALUES ('4', 'piece')
INSERT INTO [dbo].[Unit] ([ID], [Unit]) VALUES ('5', 'liter')
INSERT INTO [dbo].[Unit] ([ID], [Unit]) VALUES ('6', 'ml')
INSERT INTO [dbo].[Unit] ([ID], [Unit]) VALUES ('7', 'teaspoon')
SET IDENTITY_INSERT Unit OFF
SET IDENTITY_INSERT Ingredients_Category ON
INSERT INTO [dbo].[Ingredients_Category] ([ID], [Name]) VALUES ('1', 'Vegitable')
INSERT INTO [dbo].[Ingredients_Category] ([ID], [Name]) VALUES ('2', 'Meat')
INSERT INTO [dbo].[Ingredients_Category] ([ID], [Name]) VALUES ('3', 'Dairy')
INSERT INTO [dbo].[Ingredients_Category] ([ID], [Name]) VALUES ('4', 'Spice')
SET IDENTITY_INSERT Ingredients_Category OFF
SET IDENTITY_INSERT Ingredients ON
INSERT INTO [dbo].[Ingredients]([ID],[Name],[Category],[Carbohydrate],[Protein],[Calories],[Fat],[PeiceToGram]) VALUES ('1', 'Cucumber', '2', '2', '14', '2', '59', '11')
INSERT INTO [dbo].[Ingredients]([ID],[Name],[Category],[Carbohydrate],[Protein],[Calories],[Fat],[PeiceToGram]) VALUES ('2', 'Broccoli', '3', '3', '38', '3', '82', '6')
INSERT INTO [dbo].[Ingredients]([ID],[Name],[Category],[Carbohydrate],[Protein],[Calories],[Fat],[PeiceToGram]) VALUES ('3', 'Pork', '3', '3', '68', '3', '29', '15')
INSERT INTO [dbo].[Ingredients]([ID],[Name],[Category],[Carbohydrate],[Protein],[Calories],[Fat],[PeiceToGram]) VALUES ('4', 'Lamb', '2', '2', '51', '2', '51', '4')
INSERT INTO [dbo].[Ingredients]([ID],[Name],[Category],[Carbohydrate],[Protein],[Calories],[Fat],[PeiceToGram]) VALUES ('5', 'Beef', '2', '2', '61', '2', '50', '17')
SET IDENTITY_INSERT Ingredients OFF
SET IDENTITY_INSERT RecipeNameKeyWord ON
INSERT INTO [dbo].[RecipeNameKeyWord] ([ID], [KeyWord]) VALUES('1', 'fried')
INSERT INTO [dbo].[RecipeNameKeyWord] ([ID], [KeyWord]) VALUES('2', 'steamed')
INSERT INTO [dbo].[RecipeNameKeyWord] ([ID], [KeyWord]) VALUES('3', 'roasted')
INSERT INTO [dbo].[RecipeNameKeyWord] ([ID], [KeyWord]) VALUES('4', 'lasagna')
INSERT INTO [dbo].[RecipeNameKeyWord] ([ID], [KeyWord]) VALUES('5', 'sandwiches')
INSERT INTO [dbo].[RecipeNameKeyWord] ([ID], [KeyWord]) VALUES('6', 'tacos')
INSERT INTO [dbo].[RecipeNameKeyWord] ([ID], [KeyWord]) VALUES('7', 'cucumber')
INSERT INTO [dbo].[RecipeNameKeyWord] ([ID], [KeyWord]) VALUES('8', 'pork')
INSERT INTO [dbo].[RecipeNameKeyWord] ([ID], [KeyWord]) VALUES('9', 'chicken')
INSERT INTO [dbo].[RecipeNameKeyWord] ([ID], [KeyWord]) VALUES('10', 'italian')
INSERT INTO [dbo].[RecipeNameKeyWord] ([ID], [KeyWord]) VALUES('11', 'sausage')
INSERT INTO [dbo].[RecipeNameKeyWord] ([ID], [KeyWord]) VALUES('12', 'tomato')
SET IDENTITY_INSERT RecipeNameKeyWord OFF
SET IDENTITY_INSERT Recipe ON
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('1', 'chicken tacos', '80', '4', 'In a large mixing bowl, combine the flour and black pepper to taste. Dredge the rump roast in the flour and cover evenly. Shake off excess.In a small bowl, combine the soup mix, mushroom soup, and vermouth or white wine; pour over roast.', 'RoastBeef.jpg', '16', '15', '11', '37')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('2', 'cucumber tacos', '19', '2', 'In a large pot over medium/high heat, melt the butter and brown the roast on all sides. Place in a 4 quart casserole dish with lid.In a small bowl, combine the soup mix, mushroom soup, and vermouth or white wine; pour over roast.', 'RoastBeef.jpg', '17', '14', '179', '4')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('3', 'fried sausage', '4', '4', 'Preheat oven to 165 degrees C(325 degrees F ).In a large pot over medium/high heat, melt the butter and brown the roast on all sides. Place in a 4 quart casserole dish with lid.', 'Potato.jpg', '29', '2', '382', '33')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('4', 'tomato tacos', '39', '4', 'In a small bowl, combine the soup mix, mushroom soup, and vermouth or white wine; pour over roast.In a large mixing bowl, combine the flour and black pepper to taste. Dredge the rump roast in the flour and cover evenly. Shake off excess.', 'Potato.jpg', '15', '14', '345', '30')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('5', 'roasted pork', '79', '4', 'In a small bowl, combine the soup mix, mushroom soup, and vermouth or white wine; pour over roast.In a large pot over medium/high heat, melt the butter and brown the roast on all sides. Place in a 4 quart casserole dish with lid.', 'RoastBeef.jpg', '8', '27', '244', '17')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('6', 'fried chicken', '44', '4', 'In a large pot over medium/high heat, melt the butter and brown the roast on all sides. Place in a 4 quart casserole dish with lid.In a small bowl, combine the soup mix, mushroom soup, and vermouth or white wine; pour over roast.', 'RoastBeef.jpg', '22', '33', '65', '9')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('7', 'italian sandwiches', '94', '3', 'Preheat oven to 165 degrees C(325 degrees F ).In a large pot over medium/high heat, melt the butter and brown the roast on all sides. Place in a 4 quart casserole dish with lid.', 'Potato.jpg', '9', '29', '293', '14')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('8', 'chicken sandwiches', '99', '1', 'In a large pot over medium/high heat, melt the butter and brown the roast on all sides. Place in a 4 quart casserole dish with lid.In a small bowl, combine the soup mix, mushroom soup, and vermouth or white wine; pour over roast.', 'RoastBeef.jpg', '8', '12', '352', '38')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('9', 'roasted chicken', '99', '3', 'In a large pot over medium/high heat, melt the butter and brown the roast on all sides. Place in a 4 quart casserole dish with lid.In a large pot over medium/high heat, melt the butter and brown the roast on all sides. Place in a 4 quart casserole dish with lid.', 'Potato.jpg', '32', '1', '278', '2')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('10', 'steamed sausage', '65', '1', 'In a small bowl, combine the soup mix, mushroom soup, and vermouth or white wine; pour over roast.In a small bowl, combine the soup mix, mushroom soup, and vermouth or white wine; pour over roast.', 'Potato.jpg', '39', '32', '384', '24')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('11', 'sausage lasagna', '46', '2', 'Preheat oven to 165 degrees C(325 degrees F ).Preheat oven to 165 degrees C(325 degrees F ).', 'RoastBeef.jpg', '5', '2', '245', '6')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('12', 'fried pork', '19', '1', 'Preheat oven to 165 degrees C(325 degrees F ).In a small bowl, combine the soup mix, mushroom soup, and vermouth or white wine; pour over roast.', 'RoastBeef.jpg', '9', '12', '24', '5')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('13', 'tomato tacos', '40', '2', 'In a large mixing bowl, combine the flour and black pepper to taste. Dredge the rump roast in the flour and cover evenly. Shake off excess.Preheat oven to 165 degrees C(325 degrees F ).', 'RoastBeef.jpg', '28', '36', '283', '24')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('14', 'pork lasagna', '78', '4', 'In a large pot over medium/high heat, melt the butter and brown the roast on all sides. Place in a 4 quart casserole dish with lid.In a small bowl, combine the soup mix, mushroom soup, and vermouth or white wine; pour over roast.', 'Potato.jpg', '34', '27', '186', '24')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('15', 'italian lasagna', '42', '4', 'Preheat oven to 165 degrees C(325 degrees F ).In a small bowl, combine the soup mix, mushroom soup, and vermouth or white wine; pour over roast.', 'Potato.jpg', '9', '9', '237', '25')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('16', 'steamed italian', '22', '1', 'In a large mixing bowl, combine the flour and black pepper to taste. Dredge the rump roast in the flour and cover evenly. Shake off excess.In a small bowl, combine the soup mix, mushroom soup, and vermouth or white wine; pour over roast.', 'Potato.jpg', '38', '21', '377', '32')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('17', 'cucumber tacos', '84', '4', 'In a large pot over medium/high heat, melt the butter and brown the roast on all sides. Place in a 4 quart casserole dish with lid.In a small bowl, combine the soup mix, mushroom soup, and vermouth or white wine; pour over roast.', 'Potato.jpg', '18', '10', '324', '33')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('18', 'sausage lasagna', '3', '4', 'In a large mixing bowl, combine the flour and black pepper to taste. Dredge the rump roast in the flour and cover evenly. Shake off excess.In a small bowl, combine the soup mix, mushroom soup, and vermouth or white wine; pour over roast.', 'Potato.jpg', '19', '7', '323', '18')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('19', 'pork lasagna', '84', '4', 'In a small bowl, combine the soup mix, mushroom soup, and vermouth or white wine; pour over roast.Preheat oven to 165 degrees C(325 degrees F ).', 'Potato.jpg', '5', '31', '306', '29')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('20', 'fried tomato', '47', '3', 'Preheat oven to 165 degrees C(325 degrees F ).In a large mixing bowl, combine the flour and black pepper to taste. Dredge the rump roast in the flour and cover evenly. Shake off excess.', 'RoastBeef.jpg', '15', '14', '384', '13')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('21', 'sausage tacos', '69', '1', 'In a large mixing bowl, combine the flour and black pepper to taste. Dredge the rump roast in the flour and cover evenly. Shake off excess.Preheat oven to 165 degrees C(325 degrees F ).', 'Potato.jpg', '36', '29', '34', '14')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('22', 'chicken sandwiches', '28', '3', 'In a small bowl, combine the soup mix, mushroom soup, and vermouth or white wine; pour over roast.Preheat oven to 165 degrees C(325 degrees F ).', 'RoastBeef.jpg', '31', '11', '273', '10')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('23', 'italian lasagna', '37', '2', 'Preheat oven to 165 degrees C(325 degrees F ).Preheat oven to 165 degrees C(325 degrees F ).', 'RoastBeef.jpg', '24', '36', '117', '1')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('24', 'steamed tomato', '88', '2', 'In a small bowl, combine the soup mix, mushroom soup, and vermouth or white wine; pour over roast.In a small bowl, combine the soup mix, mushroom soup, and vermouth or white wine; pour over roast.', 'RoastBeef.jpg', '12', '23', '16', '9')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('25', 'pork tacos', '89', '3', 'Preheat oven to 165 degrees C(325 degrees F ).In a large mixing bowl, combine the flour and black pepper to taste. Dredge the rump roast in the flour and cover evenly. Shake off excess.', 'RoastBeef.jpg', '27', '7', '205', '27')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('26', 'pork sandwiches', '32', '4', 'In a small bowl, combine the soup mix, mushroom soup, and vermouth or white wine; pour over roast.In a small bowl, combine the soup mix, mushroom soup, and vermouth or white wine; pour over roast.', 'Potato.jpg', '14', '19', '140', '26')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('27', 'tomato tacos', '19', '4', 'In a small bowl, combine the soup mix, mushroom soup, and vermouth or white wine; pour over roast.In a large mixing bowl, combine the flour and black pepper to taste. Dredge the rump roast in the flour and cover evenly. Shake off excess.', 'Potato.jpg', '17', '33', '273', '32')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('28', 'fried chicken', '90', '3', 'In a large pot over medium/high heat, melt the butter and brown the roast on all sides. Place in a 4 quart casserole dish with lid.In a large mixing bowl, combine the flour and black pepper to taste. Dredge the rump roast in the flour and cover evenly. Shake off excess.', 'RoastBeef.jpg', '21', '19', '76', '3')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('29', 'fried cucumber', '65', '2', 'In a large pot over medium/high heat, melt the butter and brown the roast on all sides. Place in a 4 quart casserole dish with lid.In a large mixing bowl, combine the flour and black pepper to taste. Dredge the rump roast in the flour and cover evenly. Shake off excess.', 'RoastBeef.jpg', '2', '38', '26', '21')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('30', 'fried italian', '31', '1', 'In a large mixing bowl, combine the flour and black pepper to taste. Dredge the rump roast in the flour and cover evenly. Shake off excess.In a large pot over medium/high heat, melt the butter and brown the roast on all sides. Place in a 4 quart casserole dish with lid.', 'Potato.jpg', '1', '2', '357', '8')
INSERT INTO [dbo].[Recipe] ([ID], [Name] ,[Cost] ,[Rating] ,[Instruction] ,[Picture] ,[Carbohydrate] ,[Protein] ,[Calories] ,[Fat]) VALUES ('31', 'steamed chicken', '63', '2', 'Preheat oven to 165 degrees C(325 degrees F ).Preheat oven to 165 degrees C(325 degrees F ).', 'Potato.jpg', '21', '13', '296', '3')
SET IDENTITY_INSERT Recipe OFF
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('1', '9')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('1', '6')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('2', '7')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('2', '6')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('3', '1')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('3', '11')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('4', '12')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('4', '6')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('5', '3')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('5', '8')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('6', '1')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('6', '9')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('7', '10')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('7', '5')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('8', '9')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('8', '5')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('9', '3')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('9', '9')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('10', '2')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('10', '11')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('11', '11')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('11', '4')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('12', '1')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('12', '8')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('13', '12')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('13', '6')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('14', '8')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('14', '4')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('15', '10')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('15', '4')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('16', '2')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('16', '10')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('17', '7')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('17', '6')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('18', '11')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('18', '4')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('19', '8')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('19', '4')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('20', '1')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('20', '12')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('21', '11')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('21', '6')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('22', '9')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('22', '5')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('23', '10')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('23', '4')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('24', '2')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('24', '12')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('25', '8')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('25', '6')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('26', '8')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('26', '5')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('27', '12')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('27', '6')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('28', '1')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('28', '9')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('29', '1')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('29', '7')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('30', '1')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('30', '10')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('31', '2')
INSERT INTO [dbo].[Recipe_KeyWord]([RID],[KID]) VALUES ('31', '9')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('1', '1', '1', '6')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('2', '1', '4', '1')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('2', '2', '5', '4')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('3', '1', '9', '1')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('3', '2', '9', '5')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('3', '3', '9', '3')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('4', '1', '5', '2')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('4', '2', '5', '6')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('4', '3', '5', '5')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('4', '4', '9', '4')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('5', '1', '2', '4')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('5', '2', '6', '1')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('5', '3', '2', '1')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('5', '4', '2', '6')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('5', '5', '8', '4')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('6', '1', '4', '2')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('6', '2', '7', '2')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('6', '3', '3', '2')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('6', '5', '1', '2')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('7', '1', '9', '2')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('7', '2', '7', '4')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('7', '4', '5', '5')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('8', '1', '5', '6')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('8', '2', '5', '6')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('8', '4', '8', '6')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('8', '5', '1', '2')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('9', '1', '8', '6')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('9', '2', '2', '2')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('9', '5', '1', '5')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('10', '1', '7', '1')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('10', '3', '7', '4')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('11', '1', '1', '3')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('11', '3', '6', '2')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('11', '4', '8', '5')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('12', '1', '2', '1')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('12', '3', '3', '5')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('12', '4', '9', '3')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('12', '5', '2', '1')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('13', '1', '3', '1')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('13', '3', '5', '4')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('13', '5', '4', '3')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('14', '1', '3', '5')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('14', '4', '5', '3')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('15', '1', '8', '2')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('15', '4', '4', '4')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('15', '5', '9', '6')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('16', '1', '6', '5')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('16', '5', '5', '3')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('17', '2', '7', '4')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('18', '2', '5', '2')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('18', '3', '2', '5')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('19', '2', '8', '1')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('19', '3', '1', '2')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('19', '4', '1', '3')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('20', '2', '5', '2')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('20', '3', '7', '5')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('20', '4', '2', '5')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('20', '5', '8', '6')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('21', '2', '3', '6')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('21', '3', '1', '1')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('21', '5', '8', '5')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('22', '2', '1', '1')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('22', '4', '5', '2')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('23', '2', '1', '1')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('23', '4', '6', '3')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('23', '5', '8', '6')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('24', '2', '7', '4')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('24', '5', '4', '3')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('25', '3', '2', '5')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('26', '3', '9', '6')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('26', '4', '1', '1')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('27', '3', '8', '3')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('27', '4', '2', '5')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('27', '5', '1', '4')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('28', '3', '5', '1')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('28', '5', '6', '4')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('29', '4', '8', '1')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('30', '4', '3', '5')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('30', '5', '4', '2')
INSERT INTO [dbo].[Recipe_Ingredient] ([RID],[IID],[Quantity] ,[UID]) VALUES ('31', '5', '3', '4')

